How to: Rename a table.
Solution:
Select the table in the Database window, and use the 'Rename' command under the 'Edit' menu.
1) Make sure the table to rename is closed.
2) If the Database window is not active, activate the Database window.
3) Click the 'Tables' tab in the Database window.
Tables tab
4) Select the desired table from the list. (The table name is highlighted.)
5) Select the 'Edit' menu and select 'Rename'. (The name is highlighted in a box with a blinking cursor.)
Text box/Blinking cursor
6) Type the new name.
7) Press ENTER.